<?php
class Article extends Veneer_Db_Table
{
	protected $_name = 'article';
//	protected $_primary = "article_id";
//	protected $_sequence = true;
	// indexes
	protected $create_mysql = "CREATE TABLE `article` (
           `article_id` int(11) NOT NULL auto_increment,                   
           `title` varchar(100) NOT NULL,                                  
           `introtext` mediumtext NOT NULL,                                
           `complete_text` mediumtext NOT NULL,                            
           `state` tinyint(4) NOT NULL default '0',                        
           `author_id` int(11) NOT NULL,                                   
           `group_id` int(11) NOT NULL default '1',                        
           `ordering` int(11) NOT NULL default '0',                        
           `access` int(11) NOT NULL default '0',                          
           `hits` int(11) NOT NULL default '0',                            
           `url_title` varchar(100) NOT NULL,                              
           `cat_id` int(11) NOT NULL,                                      
           `block_array` mediumblob,                                       
           `dt_pubstart` datetime NOT NULL default '0000-00-00 00:00:00',  
           `dt_pubstop` datetime NOT NULL default '0000-00-00 00:00:00',   
           `dt_created` datetime NOT NULL default '0000-00-00 00:00:00',   
           `dt_modified` datetime NOT NULL default '0000-00-00 00:00:00',  
           `misc_array` text,                                              
           `user_created` int(11) NOT NULL default '0',                    
           `user_modified` int(11) NOT NULL default '0',                   
           PRIMARY KEY  (`article_id`)                                     
         ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1";

}